{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"train/tax_info.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>TAX_CATEGORIES</th>\n",
       "      <th>TAX_AMOUNT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>f000950527a6feb6c2f40c9d8477e73a439dfa0897830397</td>\n",
       "      <td>印花税</td>\n",
       "      <td>21.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>f000950527a6feb6c2f40c9d8477e73a439dfa0897830397</td>\n",
       "      <td>印花税</td>\n",
       "      <td>21.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>f000950527a6feb6c2f40c9d8477e73a439dfa0897830397</td>\n",
       "      <td>印花税</td>\n",
       "      <td>21.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>f000950527a6feb6c2f40c9d8477e73a439dfa0897830397</td>\n",
       "      <td>印花税</td>\n",
       "      <td>21.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>f000950527a6feb6c2f40c9d8477e73a439dfa0897830397</td>\n",
       "      <td>印花税</td>\n",
       "      <td>21.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29190</th>\n",
       "      <td>f000950527a6feb6cb8976eb56233ede461cb23103f85f32</td>\n",
       "      <td>印花税</td>\n",
       "      <td>60.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29191</th>\n",
       "      <td>f000950527a6feb6cb8976eb56233ede461cb23103f85f32</td>\n",
       "      <td>印花税</td>\n",
       "      <td>60.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29192</th>\n",
       "      <td>d8071a739aa75a3bbb9e08ebd134ae1289f194b70cac0e95</td>\n",
       "      <td>房产税</td>\n",
       "      <td>94.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29193</th>\n",
       "      <td>d8071a739aa75a3bbb9e08ebd134ae1289f194b70cac0e95</td>\n",
       "      <td>个人所得税</td>\n",
       "      <td>837.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29194</th>\n",
       "      <td>d8071a739aa75a3bbb9e08ebd134ae1289f194b70cac0e95</td>\n",
       "      <td>个人所得税</td>\n",
       "      <td>114.01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>29195 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                     id TAX_CATEGORIES  \\\n",
       "0      f000950527a6feb6c2f40c9d8477e73a439dfa0897830397            印花税   \n",
       "1      f000950527a6feb6c2f40c9d8477e73a439dfa0897830397            印花税   \n",
       "2      f000950527a6feb6c2f40c9d8477e73a439dfa0897830397            印花税   \n",
       "3      f000950527a6feb6c2f40c9d8477e73a439dfa0897830397            印花税   \n",
       "4      f000950527a6feb6c2f40c9d8477e73a439dfa0897830397            印花税   \n",
       "...                                                 ...            ...   \n",
       "29190  f000950527a6feb6cb8976eb56233ede461cb23103f85f32            印花税   \n",
       "29191  f000950527a6feb6cb8976eb56233ede461cb23103f85f32            印花税   \n",
       "29192  d8071a739aa75a3bbb9e08ebd134ae1289f194b70cac0e95            房产税   \n",
       "29193  d8071a739aa75a3bbb9e08ebd134ae1289f194b70cac0e95          个人所得税   \n",
       "29194  d8071a739aa75a3bbb9e08ebd134ae1289f194b70cac0e95          个人所得税   \n",
       "\n",
       "       TAX_AMOUNT  \n",
       "0           21.80  \n",
       "1           21.80  \n",
       "2           21.80  \n",
       "3           21.80  \n",
       "4           21.80  \n",
       "...           ...  \n",
       "29190       60.00  \n",
       "29191       60.00  \n",
       "29192       94.96  \n",
       "29193      837.48  \n",
       "29194      114.01  \n",
       "\n",
       "[29195 rows x 3 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "drop = ['START_DATE', 'END_DATE', 'TAX_ITEMS', 'TAXATION_BASIS', 'TAX_RATE', 'DEDUCTION']\n",
    "for p in drop:\n",
    "    del df[p]\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "id                                                TAX_CATEGORIES\n",
       "216bd2aaf4d079243f3c0bd3d6d28333c790bd3aee0ddad8  个人所得税               829.35\n",
       "                                                  印花税                 260.00\n",
       "                                                  城市维护建设税             638.54\n",
       "216bd2aaf4d079248a1cb9c41425810a25d29c1fc1d1c15a  个人所得税             25038.50\n",
       "216bd2aaf4d07924caa4f30fb76969cba69358e90e310f5e  个人所得税              2400.00\n",
       "                                                                      ...   \n",
       "f1c1045b13d183292976719cbaa4c35a642acc00976f76f9  城市维护建设税              46.50\n",
       "f1c1045b13d18329892d7c8c276306169e41550e3341d8bf  个人所得税               431.50\n",
       "                                                  城市维护建设税              31.50\n",
       "f1c1045b13d18329a4e3b117b42e6fc57f1eba9b976fa2fb  个人所得税              1705.00\n",
       "                                                  城市维护建设税             111.00\n",
       "Length: 2261, dtype: float64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "p = df.groupby(['id', 'TAX_CATEGORIES']).apply(lambda x:x[\"TAX_AMOUNT\"].sum())\n",
    "p"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>个人所得税</th>\n",
       "      <th>印花税</th>\n",
       "      <th>城市维护建设税</th>\n",
       "      <th>营业税</th>\n",
       "      <th>城镇土地使用税</th>\n",
       "      <th>企业所得税</th>\n",
       "      <th>土地增值税</th>\n",
       "      <th>房产税</th>\n",
       "      <th>水利建设专项收入</th>\n",
       "      <th>教育费附加</th>\n",
       "      <th>地方教育附加</th>\n",
       "      <th>契税</th>\n",
       "      <th>税务部门罚没收入</th>\n",
       "      <th>耕地占用税</th>\n",
       "      <th>残疾人就业保障金</th>\n",
       "      <th>其他收入</th>\n",
       "      <th>其他专项收入</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>652</th>\n",
       "      <td>216bd2aaf4d079243f3c0bd3d6d28333c790bd3aee0ddad8</td>\n",
       "      <td>829.35</td>\n",
       "      <td>260.0</td>\n",
       "      <td>638.54</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   id   个人所得税    印花税  城市维护建设税  \\\n",
       "652  216bd2aaf4d079243f3c0bd3d6d28333c790bd3aee0ddad8  829.35  260.0   638.54   \n",
       "\n",
       "     营业税  城镇土地使用税  企业所得税  土地增值税  房产税  水利建设专项收入  教育费附加  地方教育附加   契税  税务部门罚没收入  \\\n",
       "652  0.0      0.0    0.0    0.0  0.0       0.0    0.0     0.0  0.0       0.0   \n",
       "\n",
       "     耕地占用税  残疾人就业保障金  其他收入  其他专项收入  \n",
       "652    0.0       0.0   0.0     0.0  "
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new[new['id']==\"216bd2aaf4d079243f3c0bd3d6d28333c790bd3aee0ddad8\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [],
   "source": [
    "id = set(df[\"id\"].values)\n",
    "d = {}\n",
    "d['id'] = list(id)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "tax=['个人所得税', '印花税', '城市维护建设税', '营业税', '城镇土地使用税', '企业所得税', '土地增值税', '房产税', '水利建设专项收入', \n",
    "     '教育费附加', '地方教育附加', '契税', '税务部门罚没收入', '耕地占用税', '残疾人就业保障金', '其他收入', '其他专项收入']\n",
    "n = len(tax)\n",
    "table = [[] for i in range(n)]\n",
    "for i in range(n):\n",
    "    for ide in d[\"id\"]:\n",
    "        if tax[i] in p[ide].index:\n",
    "            table[i].append(p[ide][tax[i]])\n",
    "        else:\n",
    "            table[i].append(0)\n",
    "    d[tax[i]] = table[i]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[474.22,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 130896.80000000002,\n",
       " 49.2,\n",
       " 266.00000000000006,\n",
       " 68.52,\n",
       " 34906.259999999995,\n",
       " 91.77000000000001,\n",
       " 220.00999999999993,\n",
       " 5122.780000000001,\n",
       " 0,\n",
       " 817.9499999999999,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 32999.600000000006,\n",
       " 22.96,\n",
       " 0,\n",
       " 10.29,\n",
       " 249.89999999999998,\n",
       " 0,\n",
       " 7.4,\n",
       " 0,\n",
       " 0,\n",
       " 5030.14,\n",
       " 1587.76,\n",
       " 195.75,\n",
       " 0,\n",
       " 0,\n",
       " 93.7,\n",
       " 514.27,\n",
       " 0,\n",
       " 3085.03,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 110.23,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 8.02,\n",
       " 312635.07999999996,\n",
       " 38.25,\n",
       " 7150.870000000001,\n",
       " 8798.1,\n",
       " 0,\n",
       " 17.48,\n",
       " 121.99999999999997,\n",
       " 0,\n",
       " 27.89,\n",
       " 83.76,\n",
       " 19208.460000000003,\n",
       " 186.38,\n",
       " 0,\n",
       " 0,\n",
       " 705.5,\n",
       " 0,\n",
       " 0,\n",
       " 1316.0,\n",
       " 28.799999999999994,\n",
       " 375.39,\n",
       " 0,\n",
       " 11.83,\n",
       " 0,\n",
       " 0,\n",
       " 3969.65,\n",
       " 336.1499999999999,\n",
       " 1094.62,\n",
       " 0,\n",
       " 90.72999999999999,\n",
       " 959.4399999999999,\n",
       " 10.0,\n",
       " 1.53,\n",
       " 50.0,\n",
       " 0,\n",
       " 0,\n",
       " 179.51,\n",
       " 34.41,\n",
       " 2.31,\n",
       " 13.94,\n",
       " 32.99,\n",
       " 0,\n",
       " 0,\n",
       " 4.78,\n",
       " 0,\n",
       " 141.07,\n",
       " 0,\n",
       " 0,\n",
       " 39643976.82,\n",
       " 0,\n",
       " 0,\n",
       " 4478.95,\n",
       " 0,\n",
       " 0,\n",
       " 550000.0,\n",
       " 27.21,\n",
       " 125.12000000000002,\n",
       " 47.1,\n",
       " 15.51,\n",
       " 0,\n",
       " 3.2,\n",
       " 32412.23,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 8.000000000000002,\n",
       " 66.04,\n",
       " 556.3,\n",
       " 0,\n",
       " 75.53,\n",
       " 81.02,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 2108.5,\n",
       " 2.31,\n",
       " 0,\n",
       " 0,\n",
       " 99.55,\n",
       " 61.17999999999999,\n",
       " 0,\n",
       " 449.3600000000001,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 65.96000000000001,\n",
       " 0,\n",
       " 11.0,\n",
       " 32.72,\n",
       " 0,\n",
       " 56.24,\n",
       " 0,\n",
       " 618.7,\n",
       " 10.0,\n",
       " 0,\n",
       " 33.6,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 2229.13,\n",
       " 0,\n",
       " 0,\n",
       " 985.29,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 6.72,\n",
       " 0,\n",
       " 0,\n",
       " 13.32,\n",
       " 5300.99,\n",
       " 0,\n",
       " 118.00000000000003,\n",
       " 387.72000000000014,\n",
       " 13.42,\n",
       " 11.13,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 39.86,\n",
       " 0,\n",
       " 0,\n",
       " 471.44,\n",
       " 11.14,\n",
       " 0,\n",
       " 627.24,\n",
       " 5758.860000000001,\n",
       " 0,\n",
       " 3297.790000000001,\n",
       " 0,\n",
       " 28750.0,\n",
       " 1872.07,\n",
       " 2.1,\n",
       " 0,\n",
       " 23.17,\n",
       " 0,\n",
       " 0,\n",
       " 20.0,\n",
       " 414.34000000000003,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 5.7,\n",
       " 0,\n",
       " 75.73,\n",
       " 966.0,\n",
       " 0,\n",
       " 710.0,\n",
       " 45.64,\n",
       " 0,\n",
       " 0,\n",
       " 24.47,\n",
       " 0,\n",
       " 333.63000000000005,\n",
       " 0,\n",
       " 138.0,\n",
       " 146.00000000000003,\n",
       " 13361.009999999998,\n",
       " 875.9999999999998,\n",
       " 0,\n",
       " 0,\n",
       " 101833.74999999999,\n",
       " 2500.0,\n",
       " 145.03,\n",
       " 0,\n",
       " 0,\n",
       " 412.0000000000001,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 50.99,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 11175.839999999997,\n",
       " 13938.370000000003,\n",
       " 524.0,\n",
       " 39.8,\n",
       " 348.71,\n",
       " 0,\n",
       " 0,\n",
       " 233.99999999999994,\n",
       " 138.10000000000002,\n",
       " 895.83,\n",
       " 0,\n",
       " 0,\n",
       " 5563.980000000001,\n",
       " 31.41,\n",
       " 13422.919999999998,\n",
       " 0,\n",
       " 0,\n",
       " 23750.0,\n",
       " 240.0,\n",
       " 268.89,\n",
       " 2.73,\n",
       " 0,\n",
       " 550.0,\n",
       " 0,\n",
       " 14.469999999999999,\n",
       " 294.42,\n",
       " 34.8,\n",
       " 0,\n",
       " 4823.7,\n",
       " 0,\n",
       " 10822.65,\n",
       " 16.34,\n",
       " 0,\n",
       " 2153971.6,\n",
       " 100000.0,\n",
       " 0,\n",
       " 0,\n",
       " 758304.6300000001,\n",
       " 438.54,\n",
       " 151.58,\n",
       " 5714.69,\n",
       " 0,\n",
       " 10.79,\n",
       " 0,\n",
       " 299107.50000000006,\n",
       " 0,\n",
       " 471.28000000000003,\n",
       " 1.84,\n",
       " 255.43000000000004,\n",
       " 70.0,\n",
       " 0,\n",
       " 0,\n",
       " 260.47,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 1.41,\n",
       " 605.77,\n",
       " 12.4,\n",
       " 0,\n",
       " 47.1,\n",
       " 0,\n",
       " 396.00000000000006,\n",
       " 0,\n",
       " 684.22,\n",
       " 12.37,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 18905.600000000002,\n",
       " 0,\n",
       " 298.0,\n",
       " 0,\n",
       " 1250.0,\n",
       " 158.71,\n",
       " 180.39000000000001,\n",
       " 94.00000000000001,\n",
       " 815.9999999999998,\n",
       " 0,\n",
       " 0,\n",
       " 4950.02,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 4984.81,\n",
       " 28.62,\n",
       " 0,\n",
       " 42100.79999999999,\n",
       " 523.98,\n",
       " 2500.0,\n",
       " 0,\n",
       " 0,\n",
       " 43.6,\n",
       " 16.93,\n",
       " 0,\n",
       " 1.51,\n",
       " 0,\n",
       " 0,\n",
       " 11.999999999999998,\n",
       " 12.91,\n",
       " 0,\n",
       " 2.46,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 1.2,\n",
       " 0,\n",
       " 210.0,\n",
       " 3.79,\n",
       " 781.15,\n",
       " 1.69,\n",
       " 0,\n",
       " 38.17,\n",
       " 1566.69,\n",
       " 55.769999999999996,\n",
       " 148.00000000000003,\n",
       " 270.0,\n",
       " 3040.2999999999997,\n",
       " 1098413.2000000002,\n",
       " 293.99999999999994,\n",
       " 0,\n",
       " 1704.8,\n",
       " 11.75,\n",
       " 0,\n",
       " 276.00000000000006,\n",
       " 182.48,\n",
       " 10.0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 500.0,\n",
       " 5.0,\n",
       " 0,\n",
       " 280.1,\n",
       " 0,\n",
       " 20754.190000000002,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 175.14,\n",
       " 55.999999999999986,\n",
       " 179.20000000000002,\n",
       " 320.0,\n",
       " 0,\n",
       " 0,\n",
       " 6.0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 1.28,\n",
       " 93.74,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 27.25,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 20817.74,\n",
       " 1078.04,\n",
       " 0,\n",
       " 1039.14,\n",
       " 80.78,\n",
       " 388.99999999999994,\n",
       " 2.63,\n",
       " 142.52,\n",
       " 1.36,\n",
       " 332.0000000000001,\n",
       " 1.39,\n",
       " 426.23,\n",
       " 4.86,\n",
       " 5.2,\n",
       " 0,\n",
       " 0,\n",
       " 420.0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 2010.0,\n",
       " 905.34,\n",
       " 4699.200000000001,\n",
       " 0,\n",
       " 6725.5,\n",
       " 0,\n",
       " 207.02999999999997,\n",
       " 123.72,\n",
       " 0,\n",
       " 1.83,\n",
       " 49.84,\n",
       " 0,\n",
       " 188.00000000000003,\n",
       " 0,\n",
       " 0,\n",
       " 2318.8100000000004,\n",
       " 0,\n",
       " 29.2,\n",
       " 3.08,\n",
       " 25.0,\n",
       " 0,\n",
       " 37192.58,\n",
       " 30.0,\n",
       " 635.96,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 15.0,\n",
       " 11.31,\n",
       " 1.56,\n",
       " 2540.6800000000003,\n",
       " 20.72,\n",
       " 2326.1000000000004,\n",
       " 0,\n",
       " 0,\n",
       " 6.8,\n",
       " 2318.49,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 66.96,\n",
       " 5.9,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 31.92,\n",
       " 215721.40000000002,\n",
       " 12.4,\n",
       " 238.00000000000003,\n",
       " 0,\n",
       " 11077.079999999998,\n",
       " 65.05,\n",
       " 287.99999999999994,\n",
       " 828.28,\n",
       " 272.26,\n",
       " 0,\n",
       " 187.33,\n",
       " 17.04,\n",
       " 560.96,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 45199.99,\n",
       " 0,\n",
       " 0,\n",
       " 1402.87,\n",
       " 0,\n",
       " 0,\n",
       " 33678.00000000001,\n",
       " 413.94999999999993,\n",
       " 0,\n",
       " 35210.399999999994,\n",
       " 4.71,\n",
       " 0,\n",
       " 3150.0,\n",
       " 280.22,\n",
       " 0,\n",
       " 13.22,\n",
       " 1699.7099999999998,\n",
       " 0,\n",
       " 444.95,\n",
       " 0,\n",
       " 0,\n",
       " 7355.09,\n",
       " 0,\n",
       " 0,\n",
       " 1.54,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 448.11,\n",
       " 213.85999999999996,\n",
       " 1320.3999999999996,\n",
       " 217.03,\n",
       " 167.66,\n",
       " 0,\n",
       " 17.53,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 36.93,\n",
       " 95.99000000000001,\n",
       " 266.00000000000006,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 1051.4699999999998,\n",
       " 77.66,\n",
       " 0,\n",
       " 25.5,\n",
       " 186.78,\n",
       " 0,\n",
       " 15.34,\n",
       " 6026.520000000001,\n",
       " 33.010000000000005,\n",
       " 0,\n",
       " 0,\n",
       " 24667.30000000001,\n",
       " 14946.98,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 15.96,\n",
       " 34.56,\n",
       " 0,\n",
       " 0,\n",
       " 1000.0,\n",
       " 100.0,\n",
       " 3076.000000000001,\n",
       " 468.0,\n",
       " 17.66,\n",
       " 117.84,\n",
       " 358.34,\n",
       " 261.1,\n",
       " 5.55,\n",
       " 2921.0,\n",
       " 2777.7599999999993,\n",
       " 0,\n",
       " 0,\n",
       " 181.0,\n",
       " 14.96,\n",
       " 250.0,\n",
       " 0,\n",
       " 361.36,\n",
       " 93.6,\n",
       " 0,\n",
       " 261.68,\n",
       " 19103.17,\n",
       " 0,\n",
       " 0,\n",
       " 1327.0,\n",
       " 0,\n",
       " 128.73,\n",
       " 0,\n",
       " 60.64,\n",
       " 1684.88,\n",
       " 0,\n",
       " 45.999999999999986,\n",
       " 4330.0,\n",
       " 0,\n",
       " 21.24,\n",
       " 1736246.56,\n",
       " 5.4,\n",
       " 49.21,\n",
       " 0,\n",
       " 36000.0,\n",
       " 0,\n",
       " 330.0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 2.24,\n",
       " 8.8,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 55.76,\n",
       " 5.88,\n",
       " 0,\n",
       " 2175.2,\n",
       " 0,\n",
       " 13072.050000000003,\n",
       " 0,\n",
       " 0,\n",
       " 279.75,\n",
       " 0,\n",
       " 0,\n",
       " 50.4,\n",
       " 0,\n",
       " 0,\n",
       " 988.3999999999997,\n",
       " 0,\n",
       " 17.91,\n",
       " 5.5,\n",
       " 0,\n",
       " 83.59,\n",
       " 0,\n",
       " 0,\n",
       " 89.09,\n",
       " 787.9999999999999,\n",
       " 0,\n",
       " 233.07,\n",
       " 0,\n",
       " 0,\n",
       " 5871.6,\n",
       " 86.96000000000001,\n",
       " 34.65,\n",
       " 493.96,\n",
       " 26371.0,\n",
       " 0,\n",
       " 0,\n",
       " 16.29,\n",
       " 106.65,\n",
       " 2996.31,\n",
       " 11251.159999999996,\n",
       " 13.48,\n",
       " 0,\n",
       " 5.95,\n",
       " 0,\n",
       " 0,\n",
       " 4515.2,\n",
       " 22.9,\n",
       " 0,\n",
       " 142.42,\n",
       " 1990.44,\n",
       " 260.0,\n",
       " 250.66999999999996,\n",
       " 0,\n",
       " 0,\n",
       " 62.52000000000002,\n",
       " 28930.0,\n",
       " 1.23,\n",
       " 12.07,\n",
       " 37251.7,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 66.0,\n",
       " 741.72,\n",
       " 0,\n",
       " 0,\n",
       " 131.0,\n",
       " 157.49,\n",
       " 0,\n",
       " 3498.52,\n",
       " 1816.2399999999998,\n",
       " 0,\n",
       " 865.3100000000002,\n",
       " 6.32,\n",
       " 350500.0,\n",
       " 79.0,\n",
       " 2600.0,\n",
       " 124.23,\n",
       " 0,\n",
       " 4.03,\n",
       " 0,\n",
       " 0,\n",
       " 1136.8,\n",
       " 0,\n",
       " 1130.1799999999998,\n",
       " 0,\n",
       " 0,\n",
       " 2720.770000000001,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 73488842.7,\n",
       " 0,\n",
       " 20131.199999999997,\n",
       " 74.36,\n",
       " 10.4,\n",
       " 0,\n",
       " 0,\n",
       " 345.33,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 2.67,\n",
       " 0,\n",
       " 105.5,\n",
       " 532176.09,\n",
       " 0,\n",
       " 2.26,\n",
       " 0,\n",
       " 0,\n",
       " 117.33999999999999,\n",
       " 369.65,\n",
       " 6756.8,\n",
       " 14285.42,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 1.06,\n",
       " 25021.060000000005,\n",
       " 15175.66,\n",
       " 0,\n",
       " 0,\n",
       " 1595.19,\n",
       " 0,\n",
       " 0,\n",
       " 2.5,\n",
       " 128.00000000000003,\n",
       " 0,\n",
       " 9.1,\n",
       " 18000.0,\n",
       " 0,\n",
       " 0,\n",
       " 9273.6,\n",
       " 0,\n",
       " 1661.9999999999995,\n",
       " 60.0,\n",
       " 53.6,\n",
       " 952.0400000000002,\n",
       " 5623.05,\n",
       " 7983.210000000001,\n",
       " 285.03,\n",
       " 84212.99999999999,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 8527.7,\n",
       " 1198.42,\n",
       " 0,\n",
       " 12.11,\n",
       " 632.0000000000001,\n",
       " 38242.08000000001,\n",
       " 3124.8,\n",
       " 0,\n",
       " 3139.51,\n",
       " 579.0,\n",
       " 0,\n",
       " 544.0,\n",
       " 0,\n",
       " 6187.999999999998,\n",
       " 160.7,\n",
       " 49371.14,\n",
       " 0,\n",
       " 23586.290000000005,\n",
       " 641.9000000000001,\n",
       " 0,\n",
       " 100.0,\n",
       " 0,\n",
       " 0,\n",
       " 811.7400000000002,\n",
       " 0,\n",
       " 0,\n",
       " 5.0,\n",
       " 0,\n",
       " 2391.8999999999996,\n",
       " 0,\n",
       " 200195.99,\n",
       " 211.26999999999998,\n",
       " 0,\n",
       " 156.64,\n",
       " 24.0,\n",
       " 252.05,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 3686.34,\n",
       " 0,\n",
       " 204.6,\n",
       " 113.41,\n",
       " 174687.38,\n",
       " 14.62,\n",
       " 201.6,\n",
       " 0,\n",
       " 2.18,\n",
       " 90.34,\n",
       " 0,\n",
       " 0,\n",
       " 0,\n",
       " 60.0,\n",
       " 10.78,\n",
       " 19.28,\n",
       " 452.3,\n",
       " 0,\n",
       " 0]"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d['印花税']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>个人所得税</th>\n",
       "      <th>印花税</th>\n",
       "      <th>城市维护建设税</th>\n",
       "      <th>营业税</th>\n",
       "      <th>城镇土地使用税</th>\n",
       "      <th>企业所得税</th>\n",
       "      <th>土地增值税</th>\n",
       "      <th>房产税</th>\n",
       "      <th>水利建设专项收入</th>\n",
       "      <th>教育费附加</th>\n",
       "      <th>地方教育附加</th>\n",
       "      <th>契税</th>\n",
       "      <th>税务部门罚没收入</th>\n",
       "      <th>耕地占用税</th>\n",
       "      <th>残疾人就业保障金</th>\n",
       "      <th>其他收入</th>\n",
       "      <th>其他专项收入</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>d8071a739aa75a3beb32282046708f2a2b7be5c9c651e994</td>\n",
       "      <td>295.51</td>\n",
       "      <td>474.22</td>\n",
       "      <td>1.394850e+03</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>597.79</td>\n",
       "      <td>398.53</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>9c7fa510616a6830eb848902c630f9e7591f319dbe3e0196</td>\n",
       "      <td>215.60</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4.620000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>f000950527a6feb62e418a3b268057ed5ea70201ef7a0838</td>\n",
       "      <td>6.67</td>\n",
       "      <td>0.00</td>\n",
       "      <td>8.083530e+03</td>\n",
       "      <td>8.248500e+04</td>\n",
       "      <td>0.0</td>\n",
       "      <td>87984.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>f000950527a6feb6832732c43f9198daab76e0ad6a8b9784</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1652481.6</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>277.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>f000950527a6feb613e46c498621b88852a1390ea035abf2</td>\n",
       "      <td>0.00</td>\n",
       "      <td>130896.80</td>\n",
       "      <td>1.246446e+08</td>\n",
       "      <td>1.485111e+09</td>\n",
       "      <td>16483.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>138965900.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1427600.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803</th>\n",
       "      <td>f000950527a6feb6828f213264d07040f38918a4c9afa4ab</td>\n",
       "      <td>0.00</td>\n",
       "      <td>10.78</td>\n",
       "      <td>1.381000e+02</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>804</th>\n",
       "      <td>f000950527a6feb6101e4fc863a5ce8a61895f1fee3516e8</td>\n",
       "      <td>0.00</td>\n",
       "      <td>19.28</td>\n",
       "      <td>1.188100e+02</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>805</th>\n",
       "      <td>f000950527a6feb6df40c8d7e9fce635b8a8522137506b66</td>\n",
       "      <td>1261.45</td>\n",
       "      <td>452.30</td>\n",
       "      <td>1.887048e+04</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>966.35</td>\n",
       "      <td>8087.35</td>\n",
       "      <td>5391.57</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>806</th>\n",
       "      <td>f000950527a6feb6341be11ebd203ec2e9a7d875effdf585</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>193.68</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>807</th>\n",
       "      <td>f000950527a6feb6e49483e6dce012681caae837eddea3d5</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>708.36</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>808 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   id    个人所得税        印花税  \\\n",
       "0    d8071a739aa75a3beb32282046708f2a2b7be5c9c651e994   295.51     474.22   \n",
       "1    9c7fa510616a6830eb848902c630f9e7591f319dbe3e0196   215.60       0.00   \n",
       "2    f000950527a6feb62e418a3b268057ed5ea70201ef7a0838     6.67       0.00   \n",
       "3    f000950527a6feb6832732c43f9198daab76e0ad6a8b9784     0.00       0.00   \n",
       "4    f000950527a6feb613e46c498621b88852a1390ea035abf2     0.00  130896.80   \n",
       "..                                                ...      ...        ...   \n",
       "803  f000950527a6feb6828f213264d07040f38918a4c9afa4ab     0.00      10.78   \n",
       "804  f000950527a6feb6101e4fc863a5ce8a61895f1fee3516e8     0.00      19.28   \n",
       "805  f000950527a6feb6df40c8d7e9fce635b8a8522137506b66  1261.45     452.30   \n",
       "806  f000950527a6feb6341be11ebd203ec2e9a7d875effdf585     0.00       0.00   \n",
       "807  f000950527a6feb6e49483e6dce012681caae837eddea3d5     0.00       0.00   \n",
       "\n",
       "          城市维护建设税           营业税    城镇土地使用税     企业所得税        土地增值税  房产税  \\\n",
       "0    1.394850e+03  0.000000e+00        0.0      0.00          0.0  0.0   \n",
       "1    4.620000e+01  0.000000e+00        0.0      0.00          0.0  0.0   \n",
       "2    8.083530e+03  8.248500e+04        0.0  87984.00          0.0  0.0   \n",
       "3    0.000000e+00  0.000000e+00  1652481.6      0.00          0.0  0.0   \n",
       "4    1.246446e+08  1.485111e+09    16483.0      0.00  138965900.4  0.0   \n",
       "..            ...           ...        ...       ...          ...  ...   \n",
       "803  1.381000e+02  0.000000e+00        0.0      0.00          0.0  0.0   \n",
       "804  1.188100e+02  0.000000e+00        0.0      0.00          0.0  0.0   \n",
       "805  1.887048e+04  0.000000e+00        0.0      0.00          0.0  0.0   \n",
       "806  0.000000e+00  0.000000e+00        0.0    193.68          0.0  0.0   \n",
       "807  0.000000e+00  0.000000e+00        0.0      0.00          0.0  0.0   \n",
       "\n",
       "     水利建设专项收入    教育费附加   地方教育附加         契税  税务部门罚没收入  耕地占用税  残疾人就业保障金  其他收入  \\\n",
       "0        0.00   597.79   398.53        0.0       0.0    0.0       0.0   0.0   \n",
       "1        0.00     0.00     0.00        0.0       0.0    0.0       0.0   0.0   \n",
       "2        0.00     0.00     0.00        0.0       0.0    0.0       0.0   0.0   \n",
       "3      277.01     0.00     0.00        0.0       0.0    0.0       0.0   0.0   \n",
       "4        0.00     0.00     0.00  1427600.0       0.0    0.0       0.0   0.0   \n",
       "..        ...      ...      ...        ...       ...    ...       ...   ...   \n",
       "803      0.00     0.00     0.00        0.0       0.0    0.0       0.0   0.0   \n",
       "804      0.00     0.00     0.00        0.0       0.0    0.0       0.0   0.0   \n",
       "805    966.35  8087.35  5391.57        0.0       0.0    0.0       0.0   0.0   \n",
       "806      0.00     0.00     0.00        0.0       0.0    0.0       0.0   0.0   \n",
       "807    708.36     0.00     0.00        0.0       0.0    0.0       0.0   0.0   \n",
       "\n",
       "     其他专项收入  \n",
       "0       0.0  \n",
       "1       0.0  \n",
       "2       0.0  \n",
       "3       0.0  \n",
       "4       0.0  \n",
       "..      ...  \n",
       "803     0.0  \n",
       "804     0.0  \n",
       "805     0.0  \n",
       "806     0.0  \n",
       "807     0.0  \n",
       "\n",
       "[808 rows x 18 columns]"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new = pd.DataFrame(d)\n",
    "new"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "'216bd2aaf4d079243f3c0bd3d6d28333c790bd3aee0ddad8'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "\u001b[0;32m~/miniconda3/envs/py3.6/lib/python3.6/site-packages/pandas/core/indexes/base.py\u001b[0m in \u001b[0;36mget_loc\u001b[0;34m(self, key, method, tolerance)\u001b[0m\n\u001b[1;32m   2888\u001b[0m             \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2889\u001b[0;31m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcasted_key\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2890\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mKeyError\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0merr\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;31mKeyError\u001b[0m: '216bd2aaf4d079243f3c0bd3d6d28333c790bd3aee0ddad8'",
      "\nThe above exception was the direct cause of the following exception:\n",
      "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-35-c057a3ba0aa5>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m      4\u001b[0m      '教育费附加', '地方教育附加', '契税', '税务部门罚没收入', '耕地占用税', '残疾人就业保障金', '其他收入', '其他专项收入']\n\u001b[1;32m      5\u001b[0m \u001b[0mnew_df\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mDataFrame\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 6\u001b[0;31m \u001b[0mnew_df\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"216bd2aaf4d079243f3c0bd3d6d28333c790bd3aee0ddad8\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'个人所得税'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m~/miniconda3/envs/py3.6/lib/python3.6/site-packages/pandas/core/frame.py\u001b[0m in \u001b[0;36m__getitem__\u001b[0;34m(self, key)\u001b[0m\n\u001b[1;32m   2900\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mnlevels\u001b[0m \u001b[0;34m>\u001b[0m \u001b[0;36m1\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2901\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_getitem_multilevel\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2902\u001b[0;31m             \u001b[0mindexer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2903\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mis_integer\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mindexer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2904\u001b[0m                 \u001b[0mindexer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0mindexer\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m~/miniconda3/envs/py3.6/lib/python3.6/site-packages/pandas/core/indexes/base.py\u001b[0m in \u001b[0;36mget_loc\u001b[0;34m(self, key, method, tolerance)\u001b[0m\n\u001b[1;32m   2889\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcasted_key\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2890\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mKeyError\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0merr\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2891\u001b[0;31m                 \u001b[0;32mraise\u001b[0m \u001b[0mKeyError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mfrom\u001b[0m \u001b[0merr\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2892\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2893\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mtolerance\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mKeyError\u001b[0m: '216bd2aaf4d079243f3c0bd3d6d28333c790bd3aee0ddad8'"
     ]
    }
   ],
   "source": [
    "tax=['个人所得税', '印花税', '城市维护建设税', '营业税', '城镇土地使用税', '企业所得税', '土地增值税', '房产税', '水利建设专项收入', \n",
    "     '教育费附加', '地方教育附加', '契税', '税务部门罚没收入', '耕地占用税', '残疾人就业保障金', '其他收入', '其他专项收入']\n",
    "columns = ['id', '个人所得税', '印花税', '城市维护建设税', '营业税', '城镇土地使用税', '企业所得税', '土地增值税', '房产税', '水利建设专项收入', \n",
    "     '教育费附加', '地方教育附加', '契税', '税务部门罚没收入', '耕地占用税', '残疾人就业保障金', '其他收入', '其他专项收入']\n",
    "new_df = pd.DataFrame(columns=columns)\n",
    "new_df[\"216bd2aaf4d079243f3c0bd3d6d28333c790bd3aee0ddad8\"]['个人所得税']=0"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "个人所得税       11400\n",
    "印花税          6997\n",
    "城市维护建设税      4348\n",
    "营业税          1826\n",
    "城镇土地使用税      1607\n",
    "企业所得税        1070\n",
    "土地增值税         565\n",
    "房产税           405\n",
    "水利建设专项收入      337\n",
    "教育费附加         263\n",
    "地方教育附加        262\n",
    "契税             92\n",
    "税务部门罚没收入       13\n",
    "耕地占用税           4\n",
    "残疾人就业保障金        3\n",
    "其他收入            2\n",
    "其他专项收入          1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "tax_info.csv\n",
    "\n",
    "后五项感觉可以删去"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [],
   "source": [
    "new.to_csv('tax.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "dd = pd.read_csv(\"tax.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>个人所得税</th>\n",
       "      <th>印花税</th>\n",
       "      <th>城市维护建设税</th>\n",
       "      <th>营业税</th>\n",
       "      <th>城镇土地使用税</th>\n",
       "      <th>企业所得税</th>\n",
       "      <th>土地增值税</th>\n",
       "      <th>房产税</th>\n",
       "      <th>水利建设专项收入</th>\n",
       "      <th>教育费附加</th>\n",
       "      <th>地方教育附加</th>\n",
       "      <th>契税</th>\n",
       "      <th>税务部门罚没收入</th>\n",
       "      <th>耕地占用税</th>\n",
       "      <th>残疾人就业保障金</th>\n",
       "      <th>其他收入</th>\n",
       "      <th>其他专项收入</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>d8071a739aa75a3beb32282046708f2a2b7be5c9c651e994</td>\n",
       "      <td>295.51</td>\n",
       "      <td>474.22</td>\n",
       "      <td>1.394850e+03</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>597.79</td>\n",
       "      <td>398.53</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>9c7fa510616a6830eb848902c630f9e7591f319dbe3e0196</td>\n",
       "      <td>215.60</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4.620000e+01</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>f000950527a6feb62e418a3b268057ed5ea70201ef7a0838</td>\n",
       "      <td>6.67</td>\n",
       "      <td>0.00</td>\n",
       "      <td>8.083530e+03</td>\n",
       "      <td>8.248500e+04</td>\n",
       "      <td>0.0</td>\n",
       "      <td>87984.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>f000950527a6feb6832732c43f9198daab76e0ad6a8b9784</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1652481.6</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>277.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>f000950527a6feb613e46c498621b88852a1390ea035abf2</td>\n",
       "      <td>0.00</td>\n",
       "      <td>130896.80</td>\n",
       "      <td>1.246446e+08</td>\n",
       "      <td>1.485111e+09</td>\n",
       "      <td>16483.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>138965900.4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1427600.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803</th>\n",
       "      <td>f000950527a6feb6828f213264d07040f38918a4c9afa4ab</td>\n",
       "      <td>0.00</td>\n",
       "      <td>10.78</td>\n",
       "      <td>1.381000e+02</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>804</th>\n",
       "      <td>f000950527a6feb6101e4fc863a5ce8a61895f1fee3516e8</td>\n",
       "      <td>0.00</td>\n",
       "      <td>19.28</td>\n",
       "      <td>1.188100e+02</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>805</th>\n",
       "      <td>f000950527a6feb6df40c8d7e9fce635b8a8522137506b66</td>\n",
       "      <td>1261.45</td>\n",
       "      <td>452.30</td>\n",
       "      <td>1.887048e+04</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>966.35</td>\n",
       "      <td>8087.35</td>\n",
       "      <td>5391.57</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>806</th>\n",
       "      <td>f000950527a6feb6341be11ebd203ec2e9a7d875effdf585</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>193.68</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>807</th>\n",
       "      <td>f000950527a6feb6e49483e6dce012681caae837eddea3d5</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>708.36</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>808 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   id    个人所得税        印花税  \\\n",
       "0    d8071a739aa75a3beb32282046708f2a2b7be5c9c651e994   295.51     474.22   \n",
       "1    9c7fa510616a6830eb848902c630f9e7591f319dbe3e0196   215.60       0.00   \n",
       "2    f000950527a6feb62e418a3b268057ed5ea70201ef7a0838     6.67       0.00   \n",
       "3    f000950527a6feb6832732c43f9198daab76e0ad6a8b9784     0.00       0.00   \n",
       "4    f000950527a6feb613e46c498621b88852a1390ea035abf2     0.00  130896.80   \n",
       "..                                                ...      ...        ...   \n",
       "803  f000950527a6feb6828f213264d07040f38918a4c9afa4ab     0.00      10.78   \n",
       "804  f000950527a6feb6101e4fc863a5ce8a61895f1fee3516e8     0.00      19.28   \n",
       "805  f000950527a6feb6df40c8d7e9fce635b8a8522137506b66  1261.45     452.30   \n",
       "806  f000950527a6feb6341be11ebd203ec2e9a7d875effdf585     0.00       0.00   \n",
       "807  f000950527a6feb6e49483e6dce012681caae837eddea3d5     0.00       0.00   \n",
       "\n",
       "          城市维护建设税           营业税    城镇土地使用税     企业所得税        土地增值税  房产税  \\\n",
       "0    1.394850e+03  0.000000e+00        0.0      0.00          0.0  0.0   \n",
       "1    4.620000e+01  0.000000e+00        0.0      0.00          0.0  0.0   \n",
       "2    8.083530e+03  8.248500e+04        0.0  87984.00          0.0  0.0   \n",
       "3    0.000000e+00  0.000000e+00  1652481.6      0.00          0.0  0.0   \n",
       "4    1.246446e+08  1.485111e+09    16483.0      0.00  138965900.4  0.0   \n",
       "..            ...           ...        ...       ...          ...  ...   \n",
       "803  1.381000e+02  0.000000e+00        0.0      0.00          0.0  0.0   \n",
       "804  1.188100e+02  0.000000e+00        0.0      0.00          0.0  0.0   \n",
       "805  1.887048e+04  0.000000e+00        0.0      0.00          0.0  0.0   \n",
       "806  0.000000e+00  0.000000e+00        0.0    193.68          0.0  0.0   \n",
       "807  0.000000e+00  0.000000e+00        0.0      0.00          0.0  0.0   \n",
       "\n",
       "     水利建设专项收入    教育费附加   地方教育附加         契税  税务部门罚没收入  耕地占用税  残疾人就业保障金  其他收入  \\\n",
       "0        0.00   597.79   398.53        0.0       0.0    0.0       0.0   0.0   \n",
       "1        0.00     0.00     0.00        0.0       0.0    0.0       0.0   0.0   \n",
       "2        0.00     0.00     0.00        0.0       0.0    0.0       0.0   0.0   \n",
       "3      277.01     0.00     0.00        0.0       0.0    0.0       0.0   0.0   \n",
       "4        0.00     0.00     0.00  1427600.0       0.0    0.0       0.0   0.0   \n",
       "..        ...      ...      ...        ...       ...    ...       ...   ...   \n",
       "803      0.00     0.00     0.00        0.0       0.0    0.0       0.0   0.0   \n",
       "804      0.00     0.00     0.00        0.0       0.0    0.0       0.0   0.0   \n",
       "805    966.35  8087.35  5391.57        0.0       0.0    0.0       0.0   0.0   \n",
       "806      0.00     0.00     0.00        0.0       0.0    0.0       0.0   0.0   \n",
       "807    708.36     0.00     0.00        0.0       0.0    0.0       0.0   0.0   \n",
       "\n",
       "     其他专项收入  \n",
       "0       0.0  \n",
       "1       0.0  \n",
       "2       0.0  \n",
       "3       0.0  \n",
       "4       0.0  \n",
       "..      ...  \n",
       "803     0.0  \n",
       "804     0.0  \n",
       "805     0.0  \n",
       "806     0.0  \n",
       "807     0.0  \n",
       "\n",
       "[808 rows x 18 columns]"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
